[dbo].[RelationshipCategoryRef]
CREATE TABLE [dbo].[RelationshipCategoryRef]
(
[RelationshipCategoryKey] [uniqueidentifier] NOT NULL,
[RelationshipCategoryName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RelationshipCategoryDescription] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsSystem] [bit] NOT NULL CONSTRAINT [DF_RelationshipCategoryRef_IsSystem] DEFAULT ((0)),
[IsActive] [bit] NOT NULL CONSTRAINT [DF_RelationshipCategoryRef_IsActive] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RelationshipCategoryRef] ADD CONSTRAINT [PK_RelationshipCategoryRef] PRIMARY KEY CLUSTERED ([RelationshipCategoryKey]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_RelationshipCategoryRef] ON [dbo].[RelationshipCategoryRef] ([RelationshipCategoryName]) ON [PRIMARY]
GO
